1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Drawing;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10 using System.Data.SqlClient;
11
12 namespace SoftQuanLyNhaHang.Models
13 {
14 class CongNoMod
15 {
16 protected int IdCongNo { get; set; }
17 protected string TieuDe { get; set; }
18 protected string LoaiThuChi { get; set; }
19 protected DateTime NgayTao { get; set; }
20 protected string TrangThai { get; set; }
21 protected double SoTien { get; set; }
22 protected float Thue { get; set; }
23 protected string DienGiai { get; set; }
24 protected string LyDo { get; set; }
25 protected string NhanVien { get; set; }
26 protected string DuocPheDuyet { get; set; }
27 protected string GhiChu { get; set; }
28 protected string HinhThuc { get; set; }
29
30 protected int NhapHangId { get; set; }
31 protected int PageSize { get; set; }
32 protected int PageIndex { get; set; }
33 protected DateTime ThangBaoCao { get; set; }
34 protected string MaDoiTuong { get; set; }
35 protected string TenDoiTuong { get; set; }
36
37 protected DateTime NgayKetThuc { get; set; }
38
39 public CongNoMod(int _IdCongNo)
40 {
41 IdCongNo = _IdCongNo;
42 }
43
44 public CongNoMod()
45 {
46
47 }
48
49 public CongNoMod(DateTime _ThangBaoCao, string _MaDoiTuong, string _TenDoiTuong, int _PageSize, int _PageIndex)
50 {
51 ThangBaoCao = _ThangBaoCao;
52 MaDoiTuong = _MaDoiTuong;
53 TenDoiTuong =_TenDoiTuong;
54 PageSize = _PageSize;
55 PageIndex = _PageIndex;
56 }
57
58 public CongNoMod(int _IdCongNo, string _TieuDe, string _LoaiThuChi, DateTime _NgayTao, string _TrangThai, double _SoTien, float _Thue, string _DienGiai, string _LyDo, string _NhanVien, string _DuocPheDuyet, string _GhiChu, string _HinhThuc, int _NhapHangId)
59 {
60 IdCongNo = _IdCongNo;
61 TieuDe= _TieuDe;
62 LoaiThuChi= _LoaiThuChi;
63 NgayTao= _NgayTao;
64 TrangThai= _TrangThai;
65 SoTien= _SoTien;
66 Thue= _Thue;
67 DienGiai= _DienGiai;
68 LyDo= _LyDo;
69 NhanVien= _NhanVien;
70 DuocPheDuyet= _DuocPheDuyet;
71 GhiChu= _GhiChu;
72 HinhThuc = _HinhThuc;
73 NhapHangId = _NhapHangId;
74
75 }
76
77 public CongNoMod(int _IdCongNo, string _TieuDe, string _LoaiThuChi, DateTime _NgayTao, string _TrangThai, double _SoTien, float _Thue, string _DienGiai, string _LyDo, string _NhanVien, string _DuocPheDuyet, string _GhiChu, string _HinhThuc, int _NhapHangId, DateTime _NgayKetThuc, int _PageSize, int _PageIndex)
78 {
79 IdCongNo = _IdCongNo;
80 TieuDe = _TieuDe;
81 LoaiThuChi = _LoaiThuChi;
82 NgayTao = _NgayTao;
83 TrangThai = _TrangThai;
84 SoTien = _SoTien;
85 Thue = _Thue;
86 DienGiai = _DienGiai;
87 LyDo = _LyDo;
88 NhanVien = _NhanVien;
89 DuocPheDuyet = _DuocPheDuyet;
90 GhiChu = _GhiChu;
91 HinhThuc = _HinhThuc;
92 NhapHangId = _NhapHangId;
93 NgayKetThuc = _NgayKetThuc;
94 PageSize = _PageSize;
95 PageIndex = _PageIndex;
96 }
97
98 //Them moi cong no
99 public int InsertCongNo()
100 {
101 int i = 0;
102 string[] paras = new string[14] {"@IdCongNo", "@TieuDe", "@LoaiThuChi", "@NgayTao", "@TrangThai", "@SoTien", "@Thue", "@DienGiai", "@LyDo", "@NhanVien", "@DuocPheDuyet", "@GhiChu" ,"@HinhThuc", "@NhapHangId"};
103 object[] values = new object[14] { IdCongNo, TieuDe, LoaiThuChi, NgayTao, TrangThai, SoTien, Thue, DienGiai, LyDo, NhanVien, DuocPheDuyet, GhiChu, HinhThuc, NhapHangId };
104 i = Int32.Parse(Models.connection.ExcuteScalar("tbl_CongNo_Insert", CommandType.StoredProcedure, paras, values));
105 return i;
106 }
107
108 //update cong no
109 public int UpdateCongNo()
110 {
111 int i = 0;
112 string[] paras = new string[14] { "@IdCongNo", "@TieuDe", "@LoaiThuChi", "@NgayTao", "@TrangThai", "@SoTien", "@Thue", "@DienGiai", "@LyDo", "@NhanVien", "@DuocPheDuyet", "@GhiChu", "@HinhThuc" ,"@NhapHangId"};
113 object[] values = new object[14] { IdCongNo, TieuDe, LoaiThuChi, NgayTao, TrangThai, SoTien, Thue, DienGiai, LyDo, NhanVien, DuocPheDuyet, GhiChu, HinhThuc, NhapHangId };
114 i = Models.connection.Excute_Sql("tbl_CongNo_Update", CommandType.StoredProcedure, paras, values);
115 return i;
116 }
117
118 //update by nhap hang id
119 public int UpdateCongNo_ByNhapHangId()
120 {
121 int i = 0;
122 string[] paras = new string[14] { "@IdCongNo", "@TieuDe", "@LoaiThuChi", "@NgayTao", "@TrangThai", "@SoTien", "@Thue", "@DienGiai", "@LyDo", "@NhanVien", "@DuocPheDuyet", "@GhiChu", "@HinhThuc", "@NhapHangId" };
123 object[] values = new object[14] { IdCongNo, TieuDe, LoaiThuChi, NgayTao, TrangThai, SoTien, Thue, DienGiai, LyDo, NhanVien, DuocPheDuyet, GhiChu, HinhThuc, NhapHangId };
124 i = Models.connection.Excute_Sql("tbl_CongNo_Update_ByNhapHangId", CommandType.StoredProcedure, paras, values);
125 return i;
126 }
127
128 public int DeleteCongNo()
129 {
130 int i = 0;
131 string[] paras = new string[1] { "@IdCongNo" };
132 object[] values = new object[1] { IdCongNo };
133 i = Models.connection.Excute_Sql("tbl_CongNo_Delete", CommandType.StoredProcedure, paras, values);
134 return i;
135 }
136
137
138 //Hiển thị danh sách công nợ
139 public DataSet FillDataSet_CongNo_Search()
140 {
141 DataSet ds = new DataSet();
142 string[] paras = new string[17] { "@IdCongNo", "@TieuDe", "@LoaiThuChi", "@NgayTao", "@TrangThai", "@SoTien", "@Thue", "@DienGiai", "@LyDo", "@NhanVien", "@DuocPheDuyet", "@GhiChu", "@HinhThuc", "@NhapHangId","@NgayKetThuc", "@PageSize", "@PageIndex" };
143 object[] values = new object[17] { IdCongNo, TieuDe, LoaiThuChi, NgayTao, TrangThai, SoTien, Thue, DienGiai, LyDo, NhanVien, DuocPheDuyet, GhiChu, HinhThuc, NhapHangId, NgayKetThuc, PageSize, PageIndex };
144 ds = Models.connection.FillDataSet("tbl_CongNo_Search", CommandType.StoredProcedure, paras, values);
145 return ds;
146 }
147
148 //cong no tong hoop
149 public DataSet FillDataSet_CongNo_TongHop_Search()
150 {
151 DataSet ds = new DataSet();
152 string[] paras = new string[5] { "@ThangBaoCao", "@MaDoiTuong", "@TenDoiTuong", "@PageSize", "@PageIndex" };
153 object[] values = new object[5] { ThangBaoCao, MaDoiTuong, TenDoiTuong, PageSize, PageIndex };
154 ds = Models.connection.FillDataSet("uctCongNo_TongHop", CommandType.StoredProcedure, paras, values);
155 return ds;
156 }
157 }
158 }